import sqlite3
conn = sqlite3.connect('mrsoft.db')
cursor = conn.cursor()

# cursor.execute('create table user (id int(10) primary key, name varchar(20))')
# cursor.execute('insert into user (id, name) values ("1", "MRSOFT")')
# cursor.execute('insert into user (id, name) values ("2", "Andy")')
# cursor.execute('insert into user (id, name) values ("3", "明日科技小助手")')

# cursor.execute('select * from user')
cursor.execute('select * from user where id > ?', (1,))
# result1 = cursor.fetchone()
# print(result1)

# result2 = cursor.fetchmany(2)
# print(result2)

result3 = cursor.fetchall()
print(result3)

cursor.close()
# conn.commit()
conn.close()